*! _wbod_tmpfile3 <8 Jul 2020 : 14:01:00>                 by João Pedro Azevedo
*                 auto generated and updated using _update_countrymetadata.ado 
  
 program define _wbod_tmpfile3 
  
     syntax , match(varname) [  lendingtype lendingtype_iso2 lendingtypename capital longitude latitude  ] 
  
 ******************  Values: lendingtype ****************** 
  
 qui if ("`lendingtype'" == "lendingtype") {      
  
         cap: gen lendingtype = ""  
         cap: replace lendingtype = "LNX"     if `match' == "ABW"  
         cap: replace lendingtype = "IDX"     if `match' == "AFG"  
         cap: replace lendingtype = "IBD"     if `match' == "AGO"  
         cap: replace lendingtype = "IBD"     if `match' == "ALB"  
         cap: replace lendingtype = "LNX"     if `match' == "AND"  
         cap: replace lendingtype = "LNX"     if `match' == "ARE"  
         cap: replace lendingtype = "IBD"     if `match' == "ARG"  
         cap: replace lendingtype = "IBD"     if `match' == "ARM"  
         cap: replace lendingtype = "LNX"     if `match' == "ASM"  
         cap: replace lendingtype = "IBD"     if `match' == "ATG"  
         cap: replace lendingtype = "LNX"     if `match' == "AUS"  
         cap: replace lendingtype = "LNX"     if `match' == "AUT"  
         cap: replace lendingtype = "IBD"     if `match' == "AZE"  
         cap: replace lendingtype = "IDX"     if `match' == "BDI"  
         cap: replace lendingtype = "LNX"     if `match' == "BEL"  
         cap: replace lendingtype = "IDX"     if `match' == "BEN"  
         cap: replace lendingtype = "IDX"     if `match' == "BFA"  
         cap: replace lendingtype = "IDX"     if `match' == "BGD"  
         cap: replace lendingtype = "IBD"     if `match' == "BGR"  
         cap: replace lendingtype = "LNX"     if `match' == "BHR"  
         cap: replace lendingtype = "LNX"     if `match' == "BHS"  
         cap: replace lendingtype = "IBD"     if `match' == "BIH"  
         cap: replace lendingtype = "IBD"     if `match' == "BLR"  
         cap: replace lendingtype = "IBD"     if `match' == "BLZ"  
         cap: replace lendingtype = "LNX"     if `match' == "BMU"  
         cap: replace lendingtype = "IBD"     if `match' == "BOL"  
         cap: replace lendingtype = "IBD"     if `match' == "BRA"  
         cap: replace lendingtype = "LNX"     if `match' == "BRB"  
         cap: replace lendingtype = "LNX"     if `match' == "BRN"  
         cap: replace lendingtype = "IDX"     if `match' == "BTN"  
         cap: replace lendingtype = "IBD"     if `match' == "BWA"  
         cap: replace lendingtype = "IDX"     if `match' == "CAF"  
         cap: replace lendingtype = "LNX"     if `match' == "CAN"  
         cap: replace lendingtype = "LNX"     if `match' == "CHE"  
         cap: replace lendingtype = "LNX"     if `match' == "CHI"  
         cap: replace lendingtype = "IBD"     if `match' == "CHL"  
         cap: replace lendingtype = "IBD"     if `match' == "CHN"  
         cap: replace lendingtype = "IDX"     if `match' == "CIV"  
         cap: replace lendingtype = "IDB"     if `match' == "CMR"  
         cap: replace lendingtype = "IDX"     if `match' == "COD"  
         cap: replace lendingtype = "IDB"     if `match' == "COG"  
         cap: replace lendingtype = "IBD"     if `match' == "COL"  
         cap: replace lendingtype = "IDX"     if `match' == "COM"  
         cap: replace lendingtype = "IDB"     if `match' == "CPV"  
         cap: replace lendingtype = "IBD"     if `match' == "CRI"  
         cap: replace lendingtype = "LNX"     if `match' == "CUB"  
         cap: replace lendingtype = "LNX"     if `match' == "CUW"  
         cap: replace lendingtype = "LNX"     if `match' == "CYM"  
         cap: replace lendingtype = "LNX"     if `match' == "CYP"  
         cap: replace lendingtype = "LNX"     if `match' == "CZE"  
         cap: replace lendingtype = "LNX"     if `match' == "DEU"  
         cap: replace lendingtype = "IDX"     if `match' == "DJI"  
         cap: replace lendingtype = "IDB"     if `match' == "DMA"  
         cap: replace lendingtype = "LNX"     if `match' == "DNK"  
         cap: replace lendingtype = "IBD"     if `match' == "DOM"  
         cap: replace lendingtype = "IBD"     if `match' == "DZA"  
         cap: replace lendingtype = "IBD"     if `match' == "ECU"  
         cap: replace lendingtype = "IBD"     if `match' == "EGY"  
         cap: replace lendingtype = "IDX"     if `match' == "ERI"  
         cap: replace lendingtype = "LNX"     if `match' == "ESP"  
         cap: replace lendingtype = "LNX"     if `match' == "EST"  
         cap: replace lendingtype = "IDX"     if `match' == "ETH"  
         cap: replace lendingtype = "LNX"     if `match' == "FIN"  
         cap: replace lendingtype = "IDB"     if `match' == "FJI"  
         cap: replace lendingtype = "LNX"     if `match' == "FRA"  
         cap: replace lendingtype = "LNX"     if `match' == "FRO"  
         cap: replace lendingtype = "IDX"     if `match' == "FSM"  
         cap: replace lendingtype = "IBD"     if `match' == "GAB"  
         cap: replace lendingtype = "LNX"     if `match' == "GBR"  
         cap: replace lendingtype = "IBD"     if `match' == "GEO"  
         cap: replace lendingtype = "IDX"     if `match' == "GHA"  
         cap: replace lendingtype = "LNX"     if `match' == "GIB"  
         cap: replace lendingtype = "IDX"     if `match' == "GIN"  
         cap: replace lendingtype = "IDX"     if `match' == "GMB"  
         cap: replace lendingtype = "IDX"     if `match' == "GNB"  
         cap: replace lendingtype = "IBD"     if `match' == "GNQ"  
         cap: replace lendingtype = "LNX"     if `match' == "GRC"  
         cap: replace lendingtype = "IDB"     if `match' == "GRD"  
         cap: replace lendingtype = "LNX"     if `match' == "GRL"  
         cap: replace lendingtype = "IBD"     if `match' == "GTM"  
         cap: replace lendingtype = "LNX"     if `match' == "GUM"  
         cap: replace lendingtype = "IDX"     if `match' == "GUY"  
         cap: replace lendingtype = "LNX"     if `match' == "HKG"  
         cap: replace lendingtype = "IDX"     if `match' == "HND"  
         cap: replace lendingtype = "IBD"     if `match' == "HRV"  
         cap: replace lendingtype = "IDX"     if `match' == "HTI"  
         cap: replace lendingtype = "LNX"     if `match' == "HUN"  
         cap: replace lendingtype = "IBD"     if `match' == "IDN"  
         cap: replace lendingtype = "LNX"     if `match' == "IMN"  
         cap: replace lendingtype = "IBD"     if `match' == "IND"  
         cap: replace lendingtype = "LNX"     if `match' == "IRL"  
         cap: replace lendingtype = "IBD"     if `match' == "IRN"  
         cap: replace lendingtype = "IBD"     if `match' == "IRQ"  
         cap: replace lendingtype = "LNX"     if `match' == "ISL"  
         cap: replace lendingtype = "LNX"     if `match' == "ISR"  
         cap: replace lendingtype = "LNX"     if `match' == "ITA"  
         cap: replace lendingtype = "IBD"     if `match' == "JAM"  
         cap: replace lendingtype = "IBD"     if `match' == "JOR"  
         cap: replace lendingtype = "LNX"     if `match' == "JPN"  
         cap: replace lendingtype = "IBD"     if `match' == "KAZ"  
         cap: replace lendingtype = "IDB"     if `match' == "KEN"  
         cap: replace lendingtype = "IDX"     if `match' == "KGZ"  
         cap: replace lendingtype = "IDX"     if `match' == "KHM"  
         cap: replace lendingtype = "IDX"     if `match' == "KIR"  
         cap: replace lendingtype = "IBD"     if `match' == "KNA"  
         cap: replace lendingtype = "LNX"     if `match' == "KOR"  
         cap: replace lendingtype = "LNX"     if `match' == "KWT"  
         cap: replace lendingtype = "IDX"     if `match' == "LAO"  
         cap: replace lendingtype = "IBD"     if `match' == "LBN"  
         cap: replace lendingtype = "IDX"     if `match' == "LBR"  
         cap: replace lendingtype = "IBD"     if `match' == "LBY"  
         cap: replace lendingtype = "IDB"     if `match' == "LCA"  
         cap: replace lendingtype = "LNX"     if `match' == "LIE"  
         cap: replace lendingtype = "IBD"     if `match' == "LKA"  
         cap: replace lendingtype = "IDX"     if `match' == "LSO"  
         cap: replace lendingtype = "LNX"     if `match' == "LTU"  
         cap: replace lendingtype = "LNX"     if `match' == "LUX"  
         cap: replace lendingtype = "LNX"     if `match' == "LVA"  
         cap: replace lendingtype = "LNX"     if `match' == "MAC"  
         cap: replace lendingtype = "LNX"     if `match' == "MAF"  
         cap: replace lendingtype = "IBD"     if `match' == "MAR"  
         cap: replace lendingtype = "LNX"     if `match' == "MCO"  
         cap: replace lendingtype = "IBD"     if `match' == "MDA"  
         cap: replace lendingtype = "IDX"     if `match' == "MDG"  
         cap: replace lendingtype = "IDX"     if `match' == "MDV"  
         cap: replace lendingtype = "IBD"     if `match' == "MEX"  
         cap: replace lendingtype = "IDX"     if `match' == "MHL"  
         cap: replace lendingtype = "IBD"     if `match' == "MKD"  
         cap: replace lendingtype = "IDX"     if `match' == "MLI"  
         cap: replace lendingtype = "LNX"     if `match' == "MLT"  
         cap: replace lendingtype = "IDX"     if `match' == "MMR"  
         cap: replace lendingtype = "IBD"     if `match' == "MNE"  
         cap: replace lendingtype = "IBD"     if `match' == "MNG"  
         cap: replace lendingtype = "LNX"     if `match' == "MNP"  
         cap: replace lendingtype = "IDX"     if `match' == "MOZ"  
         cap: replace lendingtype = "IDX"     if `match' == "MRT"  
         cap: replace lendingtype = "IBD"     if `match' == "MUS"  
         cap: replace lendingtype = "IDX"     if `match' == "MWI"  
         cap: replace lendingtype = "IBD"     if `match' == "MYS"  
         cap: replace lendingtype = "IBD"     if `match' == "NAM"  
         cap: replace lendingtype = "LNX"     if `match' == "NCL"  
         cap: replace lendingtype = "IDX"     if `match' == "NER"  
         cap: replace lendingtype = "IDB"     if `match' == "NGA"  
         cap: replace lendingtype = "IDX"     if `match' == "NIC"  
         cap: replace lendingtype = "LNX"     if `match' == "NLD"  
         cap: replace lendingtype = "LNX"     if `match' == "NOR"  
         cap: replace lendingtype = "IDX"     if `match' == "NPL"  
         cap: replace lendingtype = "IBD"     if `match' == "NRU"  
         cap: replace lendingtype = "LNX"     if `match' == "NZL"  
         cap: replace lendingtype = "LNX"     if `match' == "OMN"  
         cap: replace lendingtype = "IDB"     if `match' == "PAK"  
         cap: replace lendingtype = "IBD"     if `match' == "PAN"  
         cap: replace lendingtype = "IBD"     if `match' == "PER"  
         cap: replace lendingtype = "IBD"     if `match' == "PHL"  
         cap: replace lendingtype = "IBD"     if `match' == "PLW"  
         cap: replace lendingtype = "IDB"     if `match' == "PNG"  
         cap: replace lendingtype = "IBD"     if `match' == "POL"  
         cap: replace lendingtype = "LNX"     if `match' == "PRI"  
         cap: replace lendingtype = "LNX"     if `match' == "PRK"  
         cap: replace lendingtype = "LNX"     if `match' == "PRT"  
         cap: replace lendingtype = "IBD"     if `match' == "PRY"  
         cap: replace lendingtype = "LNX"     if `match' == "PSE"  
         cap: replace lendingtype = "LNX"     if `match' == "PYF"  
         cap: replace lendingtype = "LNX"     if `match' == "QAT"  
         cap: replace lendingtype = "IBD"     if `match' == "ROU"  
         cap: replace lendingtype = "IBD"     if `match' == "RUS"  
         cap: replace lendingtype = "IDX"     if `match' == "RWA"  
         cap: replace lendingtype = "LNX"     if `match' == "SAU"  
         cap: replace lendingtype = "IDX"     if `match' == "SDN"  
         cap: replace lendingtype = "IDX"     if `match' == "SEN"  
         cap: replace lendingtype = "LNX"     if `match' == "SGP"  
         cap: replace lendingtype = "IDX"     if `match' == "SLB"  
         cap: replace lendingtype = "IDX"     if `match' == "SLE"  
         cap: replace lendingtype = "IBD"     if `match' == "SLV"  
         cap: replace lendingtype = "LNX"     if `match' == "SMR"  
         cap: replace lendingtype = "IDX"     if `match' == "SOM"  
         cap: replace lendingtype = "IBD"     if `match' == "SRB"  
         cap: replace lendingtype = "IDX"     if `match' == "SSD"  
         cap: replace lendingtype = "IDX"     if `match' == "STP"  
         cap: replace lendingtype = "IBD"     if `match' == "SUR"  
         cap: replace lendingtype = "LNX"     if `match' == "SVK"  
         cap: replace lendingtype = "LNX"     if `match' == "SVN"  
         cap: replace lendingtype = "LNX"     if `match' == "SWE"  
         cap: replace lendingtype = "IBD"     if `match' == "SWZ"  
         cap: replace lendingtype = "LNX"     if `match' == "SXM"  
         cap: replace lendingtype = "IBD"     if `match' == "SYC"  
         cap: replace lendingtype = "IDX"     if `match' == "SYR"  
         cap: replace lendingtype = "LNX"     if `match' == "TCA"  
         cap: replace lendingtype = "IDX"     if `match' == "TCD"  
         cap: replace lendingtype = "IDX"     if `match' == "TGO"  
         cap: replace lendingtype = "IBD"     if `match' == "THA"  
         cap: replace lendingtype = "IDX"     if `match' == "TJK"  
         cap: replace lendingtype = "IBD"     if `match' == "TKM"  
         cap: replace lendingtype = "IDB"     if `match' == "TLS"  
         cap: replace lendingtype = "IDX"     if `match' == "TON"  
         cap: replace lendingtype = "IBD"     if `match' == "TTO"  
         cap: replace lendingtype = "IBD"     if `match' == "TUN"  
         cap: replace lendingtype = "IBD"     if `match' == "TUR"  
         cap: replace lendingtype = "IDX"     if `match' == "TUV"  
         cap: replace lendingtype = "LNX"     if `match' == "TWN"  
         cap: replace lendingtype = "IDX"     if `match' == "TZA"  
         cap: replace lendingtype = "IDX"     if `match' == "UGA"  
         cap: replace lendingtype = "IBD"     if `match' == "UKR"  
         cap: replace lendingtype = "IBD"     if `match' == "URY"  
         cap: replace lendingtype = "LNX"     if `match' == "USA"  
         cap: replace lendingtype = "IDB"     if `match' == "UZB"  
         cap: replace lendingtype = "IDB"     if `match' == "VCT"  
         cap: replace lendingtype = "IBD"     if `match' == "VEN"  
         cap: replace lendingtype = "LNX"     if `match' == "VGB"  
         cap: replace lendingtype = "LNX"     if `match' == "VIR"  
         cap: replace lendingtype = "IBD"     if `match' == "VNM"  
         cap: replace lendingtype = "IDX"     if `match' == "VUT"  
         cap: replace lendingtype = "IDX"     if `match' == "WSM"  
         cap: replace lendingtype = "IDX"     if `match' == "XKX"  
         cap: replace lendingtype = "IDX"     if `match' == "YEM"  
         cap: replace lendingtype = "IBD"     if `match' == "ZAF"  
         cap: replace lendingtype = "IDX"     if `match' == "ZMB"  
         cap: replace lendingtype = "IDB"     if `match' == "ZWE"  
  
******************  Lable: lendingtype ******************
  
     lab var lendingtype                 "Lending Type Code" 
 }        
  
 ****************************************************** 
  
 ******************  Values: lendingtype_iso2 ****************** 
  
 qui if ("`lendingtype_iso2'" == "lendingtype_iso2") {      
  
         cap: gen lendingtype_iso2 = ""  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ABW"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "AFG"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "AFR"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "AGO"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ALB"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "AND"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "ANR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "ARB"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ARE"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ARG"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ARM"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ASM"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ATG"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "AUS"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "AUT"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "AZE"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "BDI"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "BEA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "BEC"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "BEL"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "BEN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "BFA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "BGD"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BGR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "BHI"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "BHR"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "BHS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BIH"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "BLA"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BLR"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BLZ"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "BMN"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "BMU"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BOL"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BRA"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "BRB"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "BRN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "BSS"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "BTN"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "BWA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CAA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "CAF"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CAN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CEA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CEB"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CEU"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CHE"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CHI"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "CHL"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "CHN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "CIV"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CLA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CME"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "CMR"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "COD"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "COG"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "COL"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "COM"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "CPV"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "CRI"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CSA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "CSS"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CUB"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CUW"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CYM"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CYP"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "CZE"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DEA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DEC"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "DEU"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DFS"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "DJI"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DLA"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "DMA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DMN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DNF"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "DNK"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DNS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "DOM"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DSA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DSF"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DSS"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "DXS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "DZA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "EAP"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "EAR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "EAS"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "ECA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "ECS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ECU"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "EGY"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "EMU"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "ERI"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ESP"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "EST"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "ETH"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "EUU"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "FCS"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "FIN"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "FJI"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "FRA"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "FRO"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "FSM"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "FXS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "GAB"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "GBR"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "GEO"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "GHA"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "GIB"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "GIN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "GMB"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "GNB"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "GNQ"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "GRC"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "GRD"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "GRL"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "GTM"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "GUM"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "GUY"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "HIC"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "HKG"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "HND"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "HPC"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "HRV"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "HTI"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "HUN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "IBB"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "IBD"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "IBT"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "IDA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "IDB"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "IDN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "IDX"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "IMN"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "IND"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "INX"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "IRL"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "IRN"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "IRQ"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ISL"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ISR"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "ITA"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "JAM"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "JOR"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "JPN"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "KAZ"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "KEN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "KGZ"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "KHM"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "KIR"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "KNA"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "KOR"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "KWT"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LAC"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "LAO"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "LBN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "LBR"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "LBY"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "LCA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LCN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LCR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LDC"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LIC"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "LIE"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "LKA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LMC"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LMY"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "LSO"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "LTE"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "LTU"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "LUX"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "LVA"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "MAC"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "MAF"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MAR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "MCA"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "MCO"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MDA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "MDE"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MDG"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MDV"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "MEA"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MEX"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MHL"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "MIC"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MKD"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MLI"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "MLT"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MMR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "MNA"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MNE"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MNG"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "MNP"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MOZ"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MRT"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MUS"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "MWI"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "MYS"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "NAC"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "NAF"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "NAM"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "NCL"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "NER"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "NGA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "NIC"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "NLD"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "NLS"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "NOR"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "NPL"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "NRS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "NRU"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "NXS"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "NZL"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "OED"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "OMN"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "OSS"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "PAK"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "PAN"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "PER"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "PHL"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "PLW"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "PNG"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "POL"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "PRE"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "PRI"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "PRK"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "PRT"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "PRY"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "PSE"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "PSS"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "PST"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "PYF"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "QAT"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ROU"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "RRS"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "RSO"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "RUS"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "RWA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "SAS"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SAU"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "SCE"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SDN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SEN"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SGP"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SLB"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SLE"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "SLV"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SMR"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SOM"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "SRB"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "SSA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SSD"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "SSF"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "SST"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "STP"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "SUR"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SVK"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SVN"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SWE"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "SWZ"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "SXM"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "SXZ"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "SYC"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "SYR"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "TCA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "TCD"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "TEA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "TEC"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "TGO"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "THA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "TJK"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "TKM"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "TLA"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "TLS"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "TMN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "TON"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "TSA"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "TSS"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "TTO"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "TUN"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "TUR"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "TUV"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "TWN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "TZA"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "UGA"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "UKR"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "UMC"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "URY"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "USA"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "UZB"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "VCT"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "VEN"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "VGB"  
         cap: replace lendingtype_iso2 = "XX"     if `match' == "VIR"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "VNM"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "VUT"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "WLD"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "WSM"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "XKX"  
         cap: replace lendingtype_iso2 = "Aggregates"     if `match' == "XZN"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "YEM"  
         cap: replace lendingtype_iso2 = "XF"     if `match' == "ZAF"  
         cap: replace lendingtype_iso2 = "XI"     if `match' == "ZMB"  
         cap: replace lendingtype_iso2 = "XH"     if `match' == "ZWE"  
  
******************  Lable: lendingtype_iso2 ******************
  
     lab var lendingtype_iso2    "Lending Type Code (ISO 2 digits)" 
 }        
  
 ****************************************************** 
  
 ******************  Values: lendingtypename ****************** 
  
 qui if ("`lendingtypename'" == "lendingtypename") {      
  
         cap: gen lendingtypename = ""  
         cap: replace lendingtypename = "Not classified"     if `match' == "ABW"  
         cap: replace lendingtypename = "IDA"     if `match' == "AFG"  
         cap: replace lendingtypename = "IBRD"     if `match' == "AGO"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ALB"  
         cap: replace lendingtypename = "Not classified"     if `match' == "AND"  
         cap: replace lendingtypename = "Not classified"     if `match' == "ARE"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ARG"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ARM"  
         cap: replace lendingtypename = "Not classified"     if `match' == "ASM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ATG"  
         cap: replace lendingtypename = "Not classified"     if `match' == "AUS"  
         cap: replace lendingtypename = "Not classified"     if `match' == "AUT"  
         cap: replace lendingtypename = "IBRD"     if `match' == "AZE"  
         cap: replace lendingtypename = "IDA"     if `match' == "BDI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "BEL"  
         cap: replace lendingtypename = "IDA"     if `match' == "BEN"  
         cap: replace lendingtypename = "IDA"     if `match' == "BFA"  
         cap: replace lendingtypename = "IDA"     if `match' == "BGD"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BGR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "BHR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "BHS"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BIH"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BLR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BLZ"  
         cap: replace lendingtypename = "Not classified"     if `match' == "BMU"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BOL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BRA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "BRB"  
         cap: replace lendingtypename = "Not classified"     if `match' == "BRN"  
         cap: replace lendingtypename = "IDA"     if `match' == "BTN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "BWA"  
         cap: replace lendingtypename = "IDA"     if `match' == "CAF"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CAN"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CHE"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CHI"  
         cap: replace lendingtypename = "IBRD"     if `match' == "CHL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "CHN"  
         cap: replace lendingtypename = "IDA"     if `match' == "CIV"  
         cap: replace lendingtypename = "Blend"     if `match' == "CMR"  
         cap: replace lendingtypename = "IDA"     if `match' == "COD"  
         cap: replace lendingtypename = "Blend"     if `match' == "COG"  
         cap: replace lendingtypename = "IBRD"     if `match' == "COL"  
         cap: replace lendingtypename = "IDA"     if `match' == "COM"  
         cap: replace lendingtypename = "Blend"     if `match' == "CPV"  
         cap: replace lendingtypename = "IBRD"     if `match' == "CRI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CUB"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CUW"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CYM"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CYP"  
         cap: replace lendingtypename = "Not classified"     if `match' == "CZE"  
         cap: replace lendingtypename = "Not classified"     if `match' == "DEU"  
         cap: replace lendingtypename = "IDA"     if `match' == "DJI"  
         cap: replace lendingtypename = "Blend"     if `match' == "DMA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "DNK"  
         cap: replace lendingtypename = "IBRD"     if `match' == "DOM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "DZA"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ECU"  
         cap: replace lendingtypename = "IBRD"     if `match' == "EGY"  
         cap: replace lendingtypename = "IDA"     if `match' == "ERI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "ESP"  
         cap: replace lendingtypename = "Not classified"     if `match' == "EST"  
         cap: replace lendingtypename = "IDA"     if `match' == "ETH"  
         cap: replace lendingtypename = "Not classified"     if `match' == "FIN"  
         cap: replace lendingtypename = "Blend"     if `match' == "FJI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "FRA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "FRO"  
         cap: replace lendingtypename = "IDA"     if `match' == "FSM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "GAB"  
         cap: replace lendingtypename = "Not classified"     if `match' == "GBR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "GEO"  
         cap: replace lendingtypename = "IDA"     if `match' == "GHA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "GIB"  
         cap: replace lendingtypename = "IDA"     if `match' == "GIN"  
         cap: replace lendingtypename = "IDA"     if `match' == "GMB"  
         cap: replace lendingtypename = "IDA"     if `match' == "GNB"  
         cap: replace lendingtypename = "IBRD"     if `match' == "GNQ"  
         cap: replace lendingtypename = "Not classified"     if `match' == "GRC"  
         cap: replace lendingtypename = "Blend"     if `match' == "GRD"  
         cap: replace lendingtypename = "Not classified"     if `match' == "GRL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "GTM"  
         cap: replace lendingtypename = "Not classified"     if `match' == "GUM"  
         cap: replace lendingtypename = "IDA"     if `match' == "GUY"  
         cap: replace lendingtypename = "Not classified"     if `match' == "HKG"  
         cap: replace lendingtypename = "IDA"     if `match' == "HND"  
         cap: replace lendingtypename = "IBRD"     if `match' == "HRV"  
         cap: replace lendingtypename = "IDA"     if `match' == "HTI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "HUN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "IDN"  
         cap: replace lendingtypename = "Not classified"     if `match' == "IMN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "IND"  
         cap: replace lendingtypename = "Not classified"     if `match' == "IRL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "IRN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "IRQ"  
         cap: replace lendingtypename = "Not classified"     if `match' == "ISL"  
         cap: replace lendingtypename = "Not classified"     if `match' == "ISR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "ITA"  
         cap: replace lendingtypename = "IBRD"     if `match' == "JAM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "JOR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "JPN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "KAZ"  
         cap: replace lendingtypename = "Blend"     if `match' == "KEN"  
         cap: replace lendingtypename = "IDA"     if `match' == "KGZ"  
         cap: replace lendingtypename = "IDA"     if `match' == "KHM"  
         cap: replace lendingtypename = "IDA"     if `match' == "KIR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "KNA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "KOR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "KWT"  
         cap: replace lendingtypename = "IDA"     if `match' == "LAO"  
         cap: replace lendingtypename = "IBRD"     if `match' == "LBN"  
         cap: replace lendingtypename = "IDA"     if `match' == "LBR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "LBY"  
         cap: replace lendingtypename = "Blend"     if `match' == "LCA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "LIE"  
         cap: replace lendingtypename = "IBRD"     if `match' == "LKA"  
         cap: replace lendingtypename = "IDA"     if `match' == "LSO"  
         cap: replace lendingtypename = "Not classified"     if `match' == "LTU"  
         cap: replace lendingtypename = "Not classified"     if `match' == "LUX"  
         cap: replace lendingtypename = "Not classified"     if `match' == "LVA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "MAC"  
         cap: replace lendingtypename = "Not classified"     if `match' == "MAF"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MAR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "MCO"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MDA"  
         cap: replace lendingtypename = "IDA"     if `match' == "MDG"  
         cap: replace lendingtypename = "IDA"     if `match' == "MDV"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MEX"  
         cap: replace lendingtypename = "IDA"     if `match' == "MHL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MKD"  
         cap: replace lendingtypename = "IDA"     if `match' == "MLI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "MLT"  
         cap: replace lendingtypename = "IDA"     if `match' == "MMR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MNE"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MNG"  
         cap: replace lendingtypename = "Not classified"     if `match' == "MNP"  
         cap: replace lendingtypename = "IDA"     if `match' == "MOZ"  
         cap: replace lendingtypename = "IDA"     if `match' == "MRT"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MUS"  
         cap: replace lendingtypename = "IDA"     if `match' == "MWI"  
         cap: replace lendingtypename = "IBRD"     if `match' == "MYS"  
         cap: replace lendingtypename = "IBRD"     if `match' == "NAM"  
         cap: replace lendingtypename = "Not classified"     if `match' == "NCL"  
         cap: replace lendingtypename = "IDA"     if `match' == "NER"  
         cap: replace lendingtypename = "Blend"     if `match' == "NGA"  
         cap: replace lendingtypename = "IDA"     if `match' == "NIC"  
         cap: replace lendingtypename = "Not classified"     if `match' == "NLD"  
         cap: replace lendingtypename = "Not classified"     if `match' == "NOR"  
         cap: replace lendingtypename = "IDA"     if `match' == "NPL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "NRU"  
         cap: replace lendingtypename = "Not classified"     if `match' == "NZL"  
         cap: replace lendingtypename = "Not classified"     if `match' == "OMN"  
         cap: replace lendingtypename = "Blend"     if `match' == "PAK"  
         cap: replace lendingtypename = "IBRD"     if `match' == "PAN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "PER"  
         cap: replace lendingtypename = "IBRD"     if `match' == "PHL"  
         cap: replace lendingtypename = "IBRD"     if `match' == "PLW"  
         cap: replace lendingtypename = "Blend"     if `match' == "PNG"  
         cap: replace lendingtypename = "IBRD"     if `match' == "POL"  
         cap: replace lendingtypename = "Not classified"     if `match' == "PRI"  
         cap: replace lendingtypename = "Not classified"     if `match' == "PRK"  
         cap: replace lendingtypename = "Not classified"     if `match' == "PRT"  
         cap: replace lendingtypename = "IBRD"     if `match' == "PRY"  
         cap: replace lendingtypename = "Not classified"     if `match' == "PSE"  
         cap: replace lendingtypename = "Not classified"     if `match' == "PYF"  
         cap: replace lendingtypename = "Not classified"     if `match' == "QAT"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ROU"  
         cap: replace lendingtypename = "IBRD"     if `match' == "RUS"  
         cap: replace lendingtypename = "IDA"     if `match' == "RWA"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SAU"  
         cap: replace lendingtypename = "IDA"     if `match' == "SDN"  
         cap: replace lendingtypename = "IDA"     if `match' == "SEN"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SGP"  
         cap: replace lendingtypename = "IDA"     if `match' == "SLB"  
         cap: replace lendingtypename = "IDA"     if `match' == "SLE"  
         cap: replace lendingtypename = "IBRD"     if `match' == "SLV"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SMR"  
         cap: replace lendingtypename = "IDA"     if `match' == "SOM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "SRB"  
         cap: replace lendingtypename = "IDA"     if `match' == "SSD"  
         cap: replace lendingtypename = "IDA"     if `match' == "STP"  
         cap: replace lendingtypename = "IBRD"     if `match' == "SUR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SVK"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SVN"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SWE"  
         cap: replace lendingtypename = "IBRD"     if `match' == "SWZ"  
         cap: replace lendingtypename = "Not classified"     if `match' == "SXM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "SYC"  
         cap: replace lendingtypename = "IDA"     if `match' == "SYR"  
         cap: replace lendingtypename = "Not classified"     if `match' == "TCA"  
         cap: replace lendingtypename = "IDA"     if `match' == "TCD"  
         cap: replace lendingtypename = "IDA"     if `match' == "TGO"  
         cap: replace lendingtypename = "IBRD"     if `match' == "THA"  
         cap: replace lendingtypename = "IDA"     if `match' == "TJK"  
         cap: replace lendingtypename = "IBRD"     if `match' == "TKM"  
         cap: replace lendingtypename = "Blend"     if `match' == "TLS"  
         cap: replace lendingtypename = "IDA"     if `match' == "TON"  
         cap: replace lendingtypename = "IBRD"     if `match' == "TTO"  
         cap: replace lendingtypename = "IBRD"     if `match' == "TUN"  
         cap: replace lendingtypename = "IBRD"     if `match' == "TUR"  
         cap: replace lendingtypename = "IDA"     if `match' == "TUV"  
         cap: replace lendingtypename = "Not classified"     if `match' == "TWN"  
         cap: replace lendingtypename = "IDA"     if `match' == "TZA"  
         cap: replace lendingtypename = "IDA"     if `match' == "UGA"  
         cap: replace lendingtypename = "IBRD"     if `match' == "UKR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "URY"  
         cap: replace lendingtypename = "Not classified"     if `match' == "USA"  
         cap: replace lendingtypename = "Blend"     if `match' == "UZB"  
         cap: replace lendingtypename = "Blend"     if `match' == "VCT"  
         cap: replace lendingtypename = "IBRD"     if `match' == "VEN"  
         cap: replace lendingtypename = "Not classified"     if `match' == "VGB"  
         cap: replace lendingtypename = "Not classified"     if `match' == "VIR"  
         cap: replace lendingtypename = "IBRD"     if `match' == "VNM"  
         cap: replace lendingtypename = "IDA"     if `match' == "VUT"  
         cap: replace lendingtypename = "IDA"     if `match' == "WSM"  
         cap: replace lendingtypename = "IDA"     if `match' == "XKX"  
         cap: replace lendingtypename = "IDA"     if `match' == "YEM"  
         cap: replace lendingtypename = "IBRD"     if `match' == "ZAF"  
         cap: replace lendingtypename = "IDA"     if `match' == "ZMB"  
         cap: replace lendingtypename = "Blend"     if `match' == "ZWE"  
  
******************  Lable: lendingtypename ******************
  
     lab var lendingtypename     "Lending Type Name" 
 }        
  
 ****************************************************** 
  
 ******************  Values: capital ****************** 
  
 qui if ("`capital'" == "capital") {      
  
         cap: gen capital = ""  
         cap: replace capital = "Oranjestad"     if `match' == "ABW"  
         cap: replace capital = "Kabul"     if `match' == "AFG"  
         cap: replace capital = "Luanda"     if `match' == "AGO"  
         cap: replace capital = "Tirane"     if `match' == "ALB"  
         cap: replace capital = "Andorra la Vella"     if `match' == "AND"  
         cap: replace capital = "Abu Dhabi"     if `match' == "ARE"  
         cap: replace capital = "Buenos Aires"     if `match' == "ARG"  
         cap: replace capital = "Yerevan"     if `match' == "ARM"  
         cap: replace capital = "Pago Pago"     if `match' == "ASM"  
         cap: replace capital = "Saint John's"     if `match' == "ATG"  
         cap: replace capital = "Canberra"     if `match' == "AUS"  
         cap: replace capital = "Vienna"     if `match' == "AUT"  
         cap: replace capital = "Baku"     if `match' == "AZE"  
         cap: replace capital = "Bujumbura"     if `match' == "BDI"  
         cap: replace capital = "Brussels"     if `match' == "BEL"  
         cap: replace capital = "Porto-Novo"     if `match' == "BEN"  
         cap: replace capital = "Ouagadougou"     if `match' == "BFA"  
         cap: replace capital = "Dhaka"     if `match' == "BGD"  
         cap: replace capital = "Sofia"     if `match' == "BGR"  
         cap: replace capital = "Manama"     if `match' == "BHR"  
         cap: replace capital = "Nassau"     if `match' == "BHS"  
         cap: replace capital = "Sarajevo"     if `match' == "BIH"  
         cap: replace capital = "Minsk"     if `match' == "BLR"  
         cap: replace capital = "Belmopan"     if `match' == "BLZ"  
         cap: replace capital = "Hamilton"     if `match' == "BMU"  
         cap: replace capital = "La Paz"     if `match' == "BOL"  
         cap: replace capital = "Brasilia"     if `match' == "BRA"  
         cap: replace capital = "Bridgetown"     if `match' == "BRB"  
         cap: replace capital = "Bandar Seri Begawan"     if `match' == "BRN"  
         cap: replace capital = "Thimphu"     if `match' == "BTN"  
         cap: replace capital = "Gaborone"     if `match' == "BWA"  
         cap: replace capital = "Bangui"     if `match' == "CAF"  
         cap: replace capital = "Ottawa"     if `match' == "CAN"  
         cap: replace capital = "Bern"     if `match' == "CHE"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "CHI"  
         cap: replace capital = "Santiago"     if `match' == "CHL"  
         cap: replace capital = "Beijing"     if `match' == "CHN"  
         cap: replace capital = "Yamoussoukro"     if `match' == "CIV"  
         cap: replace capital = "Yaounde"     if `match' == "CMR"  
         cap: replace capital = "Kinshasa"     if `match' == "COD"  
         cap: replace capital = "Brazzaville"     if `match' == "COG"  
         cap: replace capital = "Bogota"     if `match' == "COL"  
         cap: replace capital = "Moroni"     if `match' == "COM"  
         cap: replace capital = "Praia"     if `match' == "CPV"  
         cap: replace capital = "San Jose"     if `match' == "CRI"  
         cap: replace capital = "Havana"     if `match' == "CUB"  
         cap: replace capital = "Willemstad"     if `match' == "CUW"  
         cap: replace capital = "George Town"     if `match' == "CYM"  
         cap: replace capital = "Nicosia"     if `match' == "CYP"  
         cap: replace capital = "Prague"     if `match' == "CZE"  
         cap: replace capital = "Berlin"     if `match' == "DEU"  
         cap: replace capital = "Djibouti"     if `match' == "DJI"  
         cap: replace capital = "Roseau"     if `match' == "DMA"  
         cap: replace capital = "Copenhagen"     if `match' == "DNK"  
         cap: replace capital = "Santo Domingo"     if `match' == "DOM"  
         cap: replace capital = "Algiers"     if `match' == "DZA"  
         cap: replace capital = "Quito"     if `match' == "ECU"  
         cap: replace capital = "Cairo"     if `match' == "EGY"  
         cap: replace capital = "Asmara"     if `match' == "ERI"  
         cap: replace capital = "Madrid"     if `match' == "ESP"  
         cap: replace capital = "Tallinn"     if `match' == "EST"  
         cap: replace capital = "Addis Ababa"     if `match' == "ETH"  
         cap: replace capital = "Helsinki"     if `match' == "FIN"  
         cap: replace capital = "Suva"     if `match' == "FJI"  
         cap: replace capital = "Paris"     if `match' == "FRA"  
         cap: replace capital = "Torshavn"     if `match' == "FRO"  
         cap: replace capital = "Palikir"     if `match' == "FSM"  
         cap: replace capital = "Libreville"     if `match' == "GAB"  
         cap: replace capital = "London"     if `match' == "GBR"  
         cap: replace capital = "Tbilisi"     if `match' == "GEO"  
         cap: replace capital = "Accra"     if `match' == "GHA"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "GIB"  
         cap: replace capital = "Conakry"     if `match' == "GIN"  
         cap: replace capital = "Banjul"     if `match' == "GMB"  
         cap: replace capital = "Bissau"     if `match' == "GNB"  
         cap: replace capital = "Malabo"     if `match' == "GNQ"  
         cap: replace capital = "Athens"     if `match' == "GRC"  
         cap: replace capital = "Saint George's"     if `match' == "GRD"  
         cap: replace capital = "Nuuk"     if `match' == "GRL"  
         cap: replace capital = "Guatemala City"     if `match' == "GTM"  
         cap: replace capital = "Agana"     if `match' == "GUM"  
         cap: replace capital = "Georgetown"     if `match' == "GUY"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "HKG"  
         cap: replace capital = "Tegucigalpa"     if `match' == "HND"  
         cap: replace capital = "Zagreb"     if `match' == "HRV"  
         cap: replace capital = "Port-au-Prince"     if `match' == "HTI"  
         cap: replace capital = "Budapest"     if `match' == "HUN"  
         cap: replace capital = "Jakarta"     if `match' == "IDN"  
         cap: replace capital = "Douglas"     if `match' == "IMN"  
         cap: replace capital = "New Delhi"     if `match' == "IND"  
         cap: replace capital = "Dublin"     if `match' == "IRL"  
         cap: replace capital = "Tehran"     if `match' == "IRN"  
         cap: replace capital = "Baghdad"     if `match' == "IRQ"  
         cap: replace capital = "Reykjavik"     if `match' == "ISL"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "ISR"  
         cap: replace capital = "Rome"     if `match' == "ITA"  
         cap: replace capital = "Kingston"     if `match' == "JAM"  
         cap: replace capital = "Amman"     if `match' == "JOR"  
         cap: replace capital = "Tokyo"     if `match' == "JPN"  
         cap: replace capital = "Astana"     if `match' == "KAZ"  
         cap: replace capital = "Nairobi"     if `match' == "KEN"  
         cap: replace capital = "Bishkek"     if `match' == "KGZ"  
         cap: replace capital = "Phnom Penh"     if `match' == "KHM"  
         cap: replace capital = "Tarawa"     if `match' == "KIR"  
         cap: replace capital = "Basseterre"     if `match' == "KNA"  
         cap: replace capital = "Seoul"     if `match' == "KOR"  
         cap: replace capital = "Kuwait City"     if `match' == "KWT"  
         cap: replace capital = "Vientiane"     if `match' == "LAO"  
         cap: replace capital = "Beirut"     if `match' == "LBN"  
         cap: replace capital = "Monrovia"     if `match' == "LBR"  
         cap: replace capital = "Tripoli"     if `match' == "LBY"  
         cap: replace capital = "Castries"     if `match' == "LCA"  
         cap: replace capital = "Vaduz"     if `match' == "LIE"  
         cap: replace capital = "Colombo"     if `match' == "LKA"  
         cap: replace capital = "Maseru"     if `match' == "LSO"  
         cap: replace capital = "Vilnius"     if `match' == "LTU"  
         cap: replace capital = "Luxembourg"     if `match' == "LUX"  
         cap: replace capital = "Riga"     if `match' == "LVA"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "MAC"  
         cap: replace capital = "Marigot"     if `match' == "MAF"  
         cap: replace capital = "Rabat"     if `match' == "MAR"  
         cap: replace capital = "Monaco"     if `match' == "MCO"  
         cap: replace capital = "Chisinau"     if `match' == "MDA"  
         cap: replace capital = "Antananarivo"     if `match' == "MDG"  
         cap: replace capital = "Male"     if `match' == "MDV"  
         cap: replace capital = "Mexico City"     if `match' == "MEX"  
         cap: replace capital = "Majuro"     if `match' == "MHL"  
         cap: replace capital = "Skopje"     if `match' == "MKD"  
         cap: replace capital = "Bamako"     if `match' == "MLI"  
         cap: replace capital = "Valletta"     if `match' == "MLT"  
         cap: replace capital = "Naypyidaw"     if `match' == "MMR"  
         cap: replace capital = "Podgorica"     if `match' == "MNE"  
         cap: replace capital = "Ulaanbaatar"     if `match' == "MNG"  
         cap: replace capital = "Saipan"     if `match' == "MNP"  
         cap: replace capital = "Maputo"     if `match' == "MOZ"  
         cap: replace capital = "Nouakchott"     if `match' == "MRT"  
         cap: replace capital = "Port Louis"     if `match' == "MUS"  
         cap: replace capital = "Lilongwe"     if `match' == "MWI"  
         cap: replace capital = "Kuala Lumpur"     if `match' == "MYS"  
         cap: replace capital = "Windhoek"     if `match' == "NAM"  
         cap: replace capital = "Noum'ea"     if `match' == "NCL"  
         cap: replace capital = "Niamey"     if `match' == "NER"  
         cap: replace capital = "Abuja"     if `match' == "NGA"  
         cap: replace capital = "Managua"     if `match' == "NIC"  
         cap: replace capital = "Amsterdam"     if `match' == "NLD"  
         cap: replace capital = "Oslo"     if `match' == "NOR"  
         cap: replace capital = "Kathmandu"     if `match' == "NPL"  
         cap: replace capital = "Yaren District"     if `match' == "NRU"  
         cap: replace capital = "Wellington"     if `match' == "NZL"  
         cap: replace capital = "Muscat"     if `match' == "OMN"  
         cap: replace capital = "Islamabad"     if `match' == "PAK"  
         cap: replace capital = "Panama City"     if `match' == "PAN"  
         cap: replace capital = "Lima"     if `match' == "PER"  
         cap: replace capital = "Manila"     if `match' == "PHL"  
         cap: replace capital = "Koror"     if `match' == "PLW"  
         cap: replace capital = "Port Moresby"     if `match' == "PNG"  
         cap: replace capital = "Warsaw"     if `match' == "POL"  
         cap: replace capital = "San Juan"     if `match' == "PRI"  
         cap: replace capital = "Pyongyang"     if `match' == "PRK"  
         cap: replace capital = "Lisbon"     if `match' == "PRT"  
         cap: replace capital = "Asuncion"     if `match' == "PRY"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "PSE"  
         cap: replace capital = "Papeete"     if `match' == "PYF"  
         cap: replace capital = "Doha"     if `match' == "QAT"  
         cap: replace capital = "Bucharest"     if `match' == "ROU"  
         cap: replace capital = "Moscow"     if `match' == "RUS"  
         cap: replace capital = "Kigali"     if `match' == "RWA"  
         cap: replace capital = "Riyadh"     if `match' == "SAU"  
         cap: replace capital = "Khartoum"     if `match' == "SDN"  
         cap: replace capital = "Dakar"     if `match' == "SEN"  
         cap: replace capital = "Singapore"     if `match' == "SGP"  
         cap: replace capital = "Honiara"     if `match' == "SLB"  
         cap: replace capital = "Freetown"     if `match' == "SLE"  
         cap: replace capital = "San Salvador"     if `match' == "SLV"  
         cap: replace capital = "San Marino"     if `match' == "SMR"  
         cap: replace capital = "Mogadishu"     if `match' == "SOM"  
         cap: replace capital = "Belgrade"     if `match' == "SRB"  
         cap: replace capital = "Juba"     if `match' == "SSD"  
         cap: replace capital = "Sao Tome"     if `match' == "STP"  
         cap: replace capital = "Paramaribo"     if `match' == "SUR"  
         cap: replace capital = "Bratislava"     if `match' == "SVK"  
         cap: replace capital = "Ljubljana"     if `match' == "SVN"  
         cap: replace capital = "Stockholm"     if `match' == "SWE"  
         cap: replace capital = "Mbabane"     if `match' == "SWZ"  
         cap: replace capital = "Philipsburg"     if `match' == "SXM"  
         cap: replace capital = "Victoria"     if `match' == "SYC"  
         cap: replace capital = "Damascus"     if `match' == "SYR"  
         cap: replace capital = "Grand Turk"     if `match' == "TCA"  
         cap: replace capital = "N'Djamena"     if `match' == "TCD"  
         cap: replace capital = "Lome"     if `match' == "TGO"  
         cap: replace capital = "Bangkok"     if `match' == "THA"  
         cap: replace capital = "Dushanbe"     if `match' == "TJK"  
         cap: replace capital = "Ashgabat"     if `match' == "TKM"  
         cap: replace capital = "Dili"     if `match' == "TLS"  
         cap: replace capital = "Nuku'alofa"     if `match' == "TON"  
         cap: replace capital = "Port-of-Spain"     if `match' == "TTO"  
         cap: replace capital = "Tunis"     if `match' == "TUN"  
         cap: replace capital = "Ankara"     if `match' == "TUR"  
         cap: replace capital = "Funafuti"     if `match' == "TUV"  
         cap: replace capital = "<wb:capitalCity"     if `match' == "TWN"  
         cap: replace capital = "Dodoma"     if `match' == "TZA"  
         cap: replace capital = "Kampala"     if `match' == "UGA"  
         cap: replace capital = "Kiev"     if `match' == "UKR"  
         cap: replace capital = "Montevideo"     if `match' == "URY"  
         cap: replace capital = "Washington DC"     if `match' == "USA"  
         cap: replace capital = "Tashkent"     if `match' == "UZB"  
         cap: replace capital = "Kingstown"     if `match' == "VCT"  
         cap: replace capital = "Caracas"     if `match' == "VEN"  
         cap: replace capital = "Road Town"     if `match' == "VGB"  
         cap: replace capital = "Charlotte Amalie"     if `match' == "VIR"  
         cap: replace capital = "Hanoi"     if `match' == "VNM"  
         cap: replace capital = "Port-Vila"     if `match' == "VUT"  
         cap: replace capital = "Apia"     if `match' == "WSM"  
         cap: replace capital = "Pristina"     if `match' == "XKX"  
         cap: replace capital = "Sana'a"     if `match' == "YEM"  
         cap: replace capital = "Pretoria"     if `match' == "ZAF"  
         cap: replace capital = "Lusaka"     if `match' == "ZMB"  
         cap: replace capital = "Harare"     if `match' == "ZWE"  
  
******************  Lable: capital ******************
  
     lab var capital                             "Capital Name" 
 }        
  
 ****************************************************** 
  
 ******************  Values: longitude ****************** 
  
 qui if ("`longitude'" == "longitude") {      
  
         cap: gen  double longitude = .  
         cap: replace longitude = real("-70.0167")       if `match' == "ABW"  
         cap: replace longitude = real("69.1761")       if `match' == "AFG"  
         cap: replace longitude = real("13.242")       if `match' == "AGO"  
         cap: replace longitude = real("19.8172")       if `match' == "ALB"  
         cap: replace longitude = real("1.5218")       if `match' == "AND"  
         cap: replace longitude = real("54.3705")       if `match' == "ARE"  
         cap: replace longitude = real("-58.4173")       if `match' == "ARG"  
         cap: replace longitude = real("44.509")       if `match' == "ARM"  
         cap: replace longitude = real("-170.691")       if `match' == "ASM"  
         cap: replace longitude = real("-61.8456")       if `match' == "ATG"  
         cap: replace longitude = real("149.129")       if `match' == "AUS"  
         cap: replace longitude = real("16.3798")       if `match' == "AUT"  
         cap: replace longitude = real("49.8932")       if `match' == "AZE"  
         cap: replace longitude = real("29.3639")       if `match' == "BDI"  
         cap: replace longitude = real("4.36761")       if `match' == "BEL"  
         cap: replace longitude = real("2.6323")       if `match' == "BEN"  
         cap: replace longitude = real("-1.53395")       if `match' == "BFA"  
         cap: replace longitude = real("90.4113")       if `match' == "BGD"  
         cap: replace longitude = real("23.3238")       if `match' == "BGR"  
         cap: replace longitude = real("50.5354")       if `match' == "BHR"  
         cap: replace longitude = real("-77.339")       if `match' == "BHS"  
         cap: replace longitude = real("18.4214")       if `match' == "BIH"  
         cap: replace longitude = real("27.5766")       if `match' == "BLR"  
         cap: replace longitude = real("-88.7713")       if `match' == "BLZ"  
         cap: replace longitude = real("-64.706")       if `match' == "BMU"  
         cap: replace longitude = real("-66.1936")       if `match' == "BOL"  
         cap: replace longitude = real("-47.9292")       if `match' == "BRA"  
         cap: replace longitude = real("-59.6105")       if `match' == "BRB"  
         cap: replace longitude = real("114.946")       if `match' == "BRN"  
         cap: replace longitude = real("89.6177")       if `match' == "BTN"  
         cap: replace longitude = real("25.9201")       if `match' == "BWA"  
         cap: replace longitude = real("21.6407")       if `match' == "CAF"  
         cap: replace longitude = real("-75.6919")       if `match' == "CAN"  
         cap: replace longitude = real("7.44821")       if `match' == "CHE"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "CHI"  
         cap: replace longitude = real("-70.6475")       if `match' == "CHL"  
         cap: replace longitude = real("116.286")       if `match' == "CHN"  
         cap: replace longitude = real("-4.0305")       if `match' == "CIV"  
         cap: replace longitude = real("11.5174")       if `match' == "CMR"  
         cap: replace longitude = real("15.3222")       if `match' == "COD"  
         cap: replace longitude = real("15.2662")       if `match' == "COG"  
         cap: replace longitude = real("-74.082")       if `match' == "COL"  
         cap: replace longitude = real("43.2418")       if `match' == "COM"  
         cap: replace longitude = real("-23.5087")       if `match' == "CPV"  
         cap: replace longitude = real("-84.0089")       if `match' == "CRI"  
         cap: replace longitude = real("-82.3667")       if `match' == "CUB"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "CUW"  
         cap: replace longitude = real("-81.3857")       if `match' == "CYM"  
         cap: replace longitude = real("33.3736")       if `match' == "CYP"  
         cap: replace longitude = real("14.4205")       if `match' == "CZE"  
         cap: replace longitude = real("13.4115")       if `match' == "DEU"  
         cap: replace longitude = real("43.1425")       if `match' == "DJI"  
         cap: replace longitude = real("-61.39")       if `match' == "DMA"  
         cap: replace longitude = real("12.5681")       if `match' == "DNK"  
         cap: replace longitude = real("-69.8908")       if `match' == "DOM"  
         cap: replace longitude = real("3.05097")       if `match' == "DZA"  
         cap: replace longitude = real("-78.5243")       if `match' == "ECU"  
         cap: replace longitude = real("31.2461")       if `match' == "EGY"  
         cap: replace longitude = real("38.9183")       if `match' == "ERI"  
         cap: replace longitude = real("-3.70327")       if `match' == "ESP"  
         cap: replace longitude = real("24.7586")       if `match' == "EST"  
         cap: replace longitude = real("38.7468")       if `match' == "ETH"  
         cap: replace longitude = real("24.9525")       if `match' == "FIN"  
         cap: replace longitude = real("178.399")       if `match' == "FJI"  
         cap: replace longitude = real("2.35097")       if `match' == "FRA"  
         cap: replace longitude = real("-6.91181")       if `match' == "FRO"  
         cap: replace longitude = real("158.185")       if `match' == "FSM"  
         cap: replace longitude = real("9.45162")       if `match' == "GAB"  
         cap: replace longitude = real("-0.126236")       if `match' == "GBR"  
         cap: replace longitude = real("44.793")       if `match' == "GEO"  
         cap: replace longitude = real("-0.20795")       if `match' == "GHA"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "GIB"  
         cap: replace longitude = real("-13.7")       if `match' == "GIN"  
         cap: replace longitude = real("-16.5885")       if `match' == "GMB"  
         cap: replace longitude = real("-15.1804")       if `match' == "GNB"  
         cap: replace longitude = real("8.7741")       if `match' == "GNQ"  
         cap: replace longitude = real("23.7166")       if `match' == "GRC"  
         cap: replace longitude = real("-61.7449")       if `match' == "GRD"  
         cap: replace longitude = real("-51.7214")       if `match' == "GRL"  
         cap: replace longitude = real("-90.5328")       if `match' == "GTM"  
         cap: replace longitude = real("144.794")       if `match' == "GUM"  
         cap: replace longitude = real("-58.1548")       if `match' == "GUY"  
         cap: replace longitude = real("114.109")       if `match' == "HKG"  
         cap: replace longitude = real("-87.4667")       if `match' == "HND"  
         cap: replace longitude = real("15.9614")       if `match' == "HRV"  
         cap: replace longitude = real("-72.3288")       if `match' == "HTI"  
         cap: replace longitude = real("19.0408")       if `match' == "HUN"  
         cap: replace longitude = real("106.83")       if `match' == "IDN"  
         cap: replace longitude = real("-4.47928")       if `match' == "IMN"  
         cap: replace longitude = real("77.225")       if `match' == "IND"  
         cap: replace longitude = real("-6.26749")       if `match' == "IRL"  
         cap: replace longitude = real("51.4447")       if `match' == "IRN"  
         cap: replace longitude = real("44.394")       if `match' == "IRQ"  
         cap: replace longitude = real("-21.8952")       if `match' == "ISL"  
         cap: replace longitude = real("35.2035")       if `match' == "ISR"  
         cap: replace longitude = real("12.4823")       if `match' == "ITA"  
         cap: replace longitude = real("-76.792")       if `match' == "JAM"  
         cap: replace longitude = real("35.9263")       if `match' == "JOR"  
         cap: replace longitude = real("139.77")       if `match' == "JPN"  
         cap: replace longitude = real("71.4382")       if `match' == "KAZ"  
         cap: replace longitude = real("36.8126")       if `match' == "KEN"  
         cap: replace longitude = real("74.6057")       if `match' == "KGZ"  
         cap: replace longitude = real("104.874")       if `match' == "KHM"  
         cap: replace longitude = real("172.979")       if `match' == "KIR"  
         cap: replace longitude = real("-62.7309")       if `match' == "KNA"  
         cap: replace longitude = real("126.957")       if `match' == "KOR"  
         cap: replace longitude = real("47.9824")       if `match' == "KWT"  
         cap: replace longitude = real("102.177")       if `match' == "LAO"  
         cap: replace longitude = real("35.5134")       if `match' == "LBN"  
         cap: replace longitude = real("-10.7957")       if `match' == "LBR"  
         cap: replace longitude = real("13.1072")       if `match' == "LBY"  
         cap: replace longitude = real("-60.9832")       if `match' == "LCA"  
         cap: replace longitude = real("9.52148")       if `match' == "LIE"  
         cap: replace longitude = real("79.8528")       if `match' == "LKA"  
         cap: replace longitude = real("27.7167")       if `match' == "LSO"  
         cap: replace longitude = real("25.2799")       if `match' == "LTU"  
         cap: replace longitude = real("6.1296")       if `match' == "LUX"  
         cap: replace longitude = real("24.1048")       if `match' == "LVA"  
         cap: replace longitude = real("113.55")       if `match' == "MAC"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "MAF"  
         cap: replace longitude = real("-6.8704")       if `match' == "MAR"  
         cap: replace longitude = real("7.41891")       if `match' == "MCO"  
         cap: replace longitude = real("28.8497")       if `match' == "MDA"  
         cap: replace longitude = real("45.7167")       if `match' == "MDG"  
         cap: replace longitude = real("73.5109")       if `match' == "MDV"  
         cap: replace longitude = real("-99.1276")       if `match' == "MEX"  
         cap: replace longitude = real("171.135")       if `match' == "MHL"  
         cap: replace longitude = real("21.4361")       if `match' == "MKD"  
         cap: replace longitude = real("-7.50034")       if `match' == "MLI"  
         cap: replace longitude = real("14.5189")       if `match' == "MLT"  
         cap: replace longitude = real("95.9562")       if `match' == "MMR"  
         cap: replace longitude = real("19.2595")       if `match' == "MNE"  
         cap: replace longitude = real("106.937")       if `match' == "MNG"  
         cap: replace longitude = real("145.765")       if `match' == "MNP"  
         cap: replace longitude = real("32.5713")       if `match' == "MOZ"  
         cap: replace longitude = real("-15.9824")       if `match' == "MRT"  
         cap: replace longitude = real("57.4977")       if `match' == "MUS"  
         cap: replace longitude = real("33.7703")       if `match' == "MWI"  
         cap: replace longitude = real("101.684")       if `match' == "MYS"  
         cap: replace longitude = real("17.0931")       if `match' == "NAM"  
         cap: replace longitude = real("166.464")       if `match' == "NCL"  
         cap: replace longitude = real("2.1073")       if `match' == "NER"  
         cap: replace longitude = real("7.48906")       if `match' == "NGA"  
         cap: replace longitude = real("-86.2734")       if `match' == "NIC"  
         cap: replace longitude = real("4.89095")       if `match' == "NLD"  
         cap: replace longitude = real("10.7387")       if `match' == "NOR"  
         cap: replace longitude = real("85.3157")       if `match' == "NPL"  
         cap: replace longitude = real("166.920867")       if `match' == "NRU"  
         cap: replace longitude = real("174.776")       if `match' == "NZL"  
         cap: replace longitude = real("58.5874")       if `match' == "OMN"  
         cap: replace longitude = real("72.8")       if `match' == "PAK"  
         cap: replace longitude = real("-79.5188")       if `match' == "PAN"  
         cap: replace longitude = real("-77.0465")       if `match' == "PER"  
         cap: replace longitude = real("121.035")       if `match' == "PHL"  
         cap: replace longitude = real("134.479")       if `match' == "PLW"  
         cap: replace longitude = real("147.194")       if `match' == "PNG"  
         cap: replace longitude = real("21.02")       if `match' == "POL"  
         cap: replace longitude = real("-66")       if `match' == "PRI"  
         cap: replace longitude = real("125.754")       if `match' == "PRK"  
         cap: replace longitude = real("-9.13552")       if `match' == "PRT"  
         cap: replace longitude = real("-57.6362")       if `match' == "PRY"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "PSE"  
         cap: replace longitude = real("-149.57")       if `match' == "PYF"  
         cap: replace longitude = real("51.5082")       if `match' == "QAT"  
         cap: replace longitude = real("26.0979")       if `match' == "ROU"  
         cap: replace longitude = real("37.6176")       if `match' == "RUS"  
         cap: replace longitude = real("30.0587")       if `match' == "RWA"  
         cap: replace longitude = real("46.6977")       if `match' == "SAU"  
         cap: replace longitude = real("32.5363")       if `match' == "SDN"  
         cap: replace longitude = real("-17.4734")       if `match' == "SEN"  
         cap: replace longitude = real("103.85")       if `match' == "SGP"  
         cap: replace longitude = real("159.949")       if `match' == "SLB"  
         cap: replace longitude = real("-13.2134")       if `match' == "SLE"  
         cap: replace longitude = real("-89.2073")       if `match' == "SLV"  
         cap: replace longitude = real("12.4486")       if `match' == "SMR"  
         cap: replace longitude = real("45.3254")       if `match' == "SOM"  
         cap: replace longitude = real("20.4656")       if `match' == "SRB"  
         cap: replace longitude = real("31.6")       if `match' == "SSD"  
         cap: replace longitude = real("6.6071")       if `match' == "STP"  
         cap: replace longitude = real("-55.1679")       if `match' == "SUR"  
         cap: replace longitude = real("17.1073")       if `match' == "SVK"  
         cap: replace longitude = real("14.5044")       if `match' == "SVN"  
         cap: replace longitude = real("18.0645")       if `match' == "SWE"  
         cap: replace longitude = real("31.4659")       if `match' == "SWZ"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "SXM"  
         cap: replace longitude = real("55.4466")       if `match' == "SYC"  
         cap: replace longitude = real("36.3119")       if `match' == "SYR"  
         cap: replace longitude = real("-71.141389")       if `match' == "TCA"  
         cap: replace longitude = real("15.0445")       if `match' == "TCD"  
         cap: replace longitude = real("1.2255")       if `match' == "TGO"  
         cap: replace longitude = real("100.521")       if `match' == "THA"  
         cap: replace longitude = real("68.7864")       if `match' == "TJK"  
         cap: replace longitude = real("58.3794")       if `match' == "TKM"  
         cap: replace longitude = real("125.567")       if `match' == "TLS"  
         cap: replace longitude = real("-175.216")       if `match' == "TON"  
         cap: replace longitude = real("-61.4789")       if `match' == "TTO"  
         cap: replace longitude = real("10.21")       if `match' == "TUN"  
         cap: replace longitude = real("32.3606")       if `match' == "TUR"  
         cap: replace longitude = real("179.089567")       if `match' == "TUV"  
         cap: replace longitude = real("<wb:longitude")       if `match' == "TWN"  
         cap: replace longitude = real("35.7382")       if `match' == "TZA"  
         cap: replace longitude = real("32.5729")       if `match' == "UGA"  
         cap: replace longitude = real("30.5038")       if `match' == "UKR"  
         cap: replace longitude = real("-56.0675")       if `match' == "URY"  
         cap: replace longitude = real("-77.032")       if `match' == "USA"  
         cap: replace longitude = real("69.269")       if `match' == "UZB"  
         cap: replace longitude = real("-61.2653")       if `match' == "VCT"  
         cap: replace longitude = real("-69.8371")       if `match' == "VEN"  
         cap: replace longitude = real("-64.623056")       if `match' == "VGB"  
         cap: replace longitude = real("-64.8963")       if `match' == "VIR"  
         cap: replace longitude = real("105.825")       if `match' == "VNM"  
         cap: replace longitude = real("168.321")       if `match' == "VUT"  
         cap: replace longitude = real("-171.752")       if `match' == "WSM"  
         cap: replace longitude = real("20.926")       if `match' == "XKX"  
         cap: replace longitude = real("44.2075")       if `match' == "YEM"  
         cap: replace longitude = real("28.1871")       if `match' == "ZAF"  
         cap: replace longitude = real("28.2937")       if `match' == "ZMB"  
         cap: replace longitude = real("31.0672")       if `match' == "ZWE"  
  
******************  Lable: longitude ******************
  
     lab var longitude           "Capital Longitude" 
 }        
  
 ****************************************************** 
  
 ******************  Values: latitude ****************** 
  
 qui if ("`latitude'" == "latitude") {      
  
         cap: gen  double latitude = .  
         cap: replace latitude = real("12.5167")       if `match' == "ABW"  
         cap: replace latitude = real("34.5228")       if `match' == "AFG"  
         cap: replace latitude = real("-8.81155")       if `match' == "AGO"  
         cap: replace latitude = real("41.3317")       if `match' == "ALB"  
         cap: replace latitude = real("42.5075")       if `match' == "AND"  
         cap: replace latitude = real("24.4764")       if `match' == "ARE"  
         cap: replace latitude = real("-34.6118")       if `match' == "ARG"  
         cap: replace latitude = real("40.1596")       if `match' == "ARM"  
         cap: replace latitude = real("-14.2846")       if `match' == "ASM"  
         cap: replace latitude = real("17.1175")       if `match' == "ATG"  
         cap: replace latitude = real("-35.282")       if `match' == "AUS"  
         cap: replace latitude = real("48.2201")       if `match' == "AUT"  
         cap: replace latitude = real("40.3834")       if `match' == "AZE"  
         cap: replace latitude = real("-3.3784")       if `match' == "BDI"  
         cap: replace latitude = real("50.8371")       if `match' == "BEL"  
         cap: replace latitude = real("6.4779")       if `match' == "BEN"  
         cap: replace latitude = real("12.3605")       if `match' == "BFA"  
         cap: replace latitude = real("23.7055")       if `match' == "BGD"  
         cap: replace latitude = real("42.7105")       if `match' == "BGR"  
         cap: replace latitude = real("26.1921")       if `match' == "BHR"  
         cap: replace latitude = real("25.0661")       if `match' == "BHS"  
         cap: replace latitude = real("43.8607")       if `match' == "BIH"  
         cap: replace latitude = real("53.9678")       if `match' == "BLR"  
         cap: replace latitude = real("17.2534")       if `match' == "BLZ"  
         cap: replace latitude = real("32.3293")       if `match' == "BMU"  
         cap: replace latitude = real("-13.9908")       if `match' == "BOL"  
         cap: replace latitude = real("-15.7801")       if `match' == "BRA"  
         cap: replace latitude = real("13.0935")       if `match' == "BRB"  
         cap: replace latitude = real("4.94199")       if `match' == "BRN"  
         cap: replace latitude = real("27.5768")       if `match' == "BTN"  
         cap: replace latitude = real("-24.6544")       if `match' == "BWA"  
         cap: replace latitude = real("5.63056")       if `match' == "CAF"  
         cap: replace latitude = real("45.4215")       if `match' == "CAN"  
         cap: replace latitude = real("46.948")       if `match' == "CHE"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "CHI"  
         cap: replace latitude = real("-33.475")       if `match' == "CHL"  
         cap: replace latitude = real("40.0495")       if `match' == "CHN"  
         cap: replace latitude = real("5.332")       if `match' == "CIV"  
         cap: replace latitude = real("3.8721")       if `match' == "CMR"  
         cap: replace latitude = real("-4.325")       if `match' == "COD"  
         cap: replace latitude = real("-4.2767")       if `match' == "COG"  
         cap: replace latitude = real("4.60987")       if `match' == "COL"  
         cap: replace latitude = real("-11.6986")       if `match' == "COM"  
         cap: replace latitude = real("14.9218")       if `match' == "CPV"  
         cap: replace latitude = real("9.63701")       if `match' == "CRI"  
         cap: replace latitude = real("23.1333")       if `match' == "CUB"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "CUW"  
         cap: replace latitude = real("19.3022")       if `match' == "CYM"  
         cap: replace latitude = real("35.1676")       if `match' == "CYP"  
         cap: replace latitude = real("50.0878")       if `match' == "CZE"  
         cap: replace latitude = real("52.5235")       if `match' == "DEU"  
         cap: replace latitude = real("11.5806")       if `match' == "DJI"  
         cap: replace latitude = real("15.2976")       if `match' == "DMA"  
         cap: replace latitude = real("55.6763")       if `match' == "DNK"  
         cap: replace latitude = real("18.479")       if `match' == "DOM"  
         cap: replace latitude = real("36.7397")       if `match' == "DZA"  
         cap: replace latitude = real("-0.229498")       if `match' == "ECU"  
         cap: replace latitude = real("30.0982")       if `match' == "EGY"  
         cap: replace latitude = real("15.3315")       if `match' == "ERI"  
         cap: replace latitude = real("40.4167")       if `match' == "ESP"  
         cap: replace latitude = real("59.4392")       if `match' == "EST"  
         cap: replace latitude = real("9.02274")       if `match' == "ETH"  
         cap: replace latitude = real("60.1608")       if `match' == "FIN"  
         cap: replace latitude = real("-18.1149")       if `match' == "FJI"  
         cap: replace latitude = real("48.8566")       if `match' == "FRA"  
         cap: replace latitude = real("61.8926")       if `match' == "FRO"  
         cap: replace latitude = real("6.91771")       if `match' == "FSM"  
         cap: replace latitude = real("0.38832")       if `match' == "GAB"  
         cap: replace latitude = real("51.5002")       if `match' == "GBR"  
         cap: replace latitude = real("41.71")       if `match' == "GEO"  
         cap: replace latitude = real("5.57045")       if `match' == "GHA"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "GIB"  
         cap: replace latitude = real("9.51667")       if `match' == "GIN"  
         cap: replace latitude = real("13.4495")       if `match' == "GMB"  
         cap: replace latitude = real("11.8037")       if `match' == "GNB"  
         cap: replace latitude = real("3.7523")       if `match' == "GNQ"  
         cap: replace latitude = real("37.9792")       if `match' == "GRC"  
         cap: replace latitude = real("12.0653")       if `match' == "GRD"  
         cap: replace latitude = real("64.1836")       if `match' == "GRL"  
         cap: replace latitude = real("14.6248")       if `match' == "GTM"  
         cap: replace latitude = real("13.4443")       if `match' == "GUM"  
         cap: replace latitude = real("6.80461")       if `match' == "GUY"  
         cap: replace latitude = real("22.3964")       if `match' == "HKG"  
         cap: replace latitude = real("15.1333")       if `match' == "HND"  
         cap: replace latitude = real("45.8069")       if `match' == "HRV"  
         cap: replace latitude = real("18.5392")       if `match' == "HTI"  
         cap: replace latitude = real("47.4984")       if `match' == "HUN"  
         cap: replace latitude = real("-6.19752")       if `match' == "IDN"  
         cap: replace latitude = real("54.1509")       if `match' == "IMN"  
         cap: replace latitude = real("28.6353")       if `match' == "IND"  
         cap: replace latitude = real("53.3441")       if `match' == "IRL"  
         cap: replace latitude = real("35.6878")       if `match' == "IRN"  
         cap: replace latitude = real("33.3302")       if `match' == "IRQ"  
         cap: replace latitude = real("64.1353")       if `match' == "ISL"  
         cap: replace latitude = real("31.7717")       if `match' == "ISR"  
         cap: replace latitude = real("41.8955")       if `match' == "ITA"  
         cap: replace latitude = real("17.9927")       if `match' == "JAM"  
         cap: replace latitude = real("31.9497")       if `match' == "JOR"  
         cap: replace latitude = real("35.67")       if `match' == "JPN"  
         cap: replace latitude = real("51.1879")       if `match' == "KAZ"  
         cap: replace latitude = real("-1.27975")       if `match' == "KEN"  
         cap: replace latitude = real("42.8851")       if `match' == "KGZ"  
         cap: replace latitude = real("11.5556")       if `match' == "KHM"  
         cap: replace latitude = real("1.32905")       if `match' == "KIR"  
         cap: replace latitude = real("17.3")       if `match' == "KNA"  
         cap: replace latitude = real("37.5323")       if `match' == "KOR"  
         cap: replace latitude = real("29.3721")       if `match' == "KWT"  
         cap: replace latitude = real("18.5826")       if `match' == "LAO"  
         cap: replace latitude = real("33.8872")       if `match' == "LBN"  
         cap: replace latitude = real("6.30039")       if `match' == "LBR"  
         cap: replace latitude = real("32.8578")       if `match' == "LBY"  
         cap: replace latitude = real("14")       if `match' == "LCA"  
         cap: replace latitude = real("47.1411")       if `match' == "LIE"  
         cap: replace latitude = real("6.92148")       if `match' == "LKA"  
         cap: replace latitude = real("-29.5208")       if `match' == "LSO"  
         cap: replace latitude = real("54.6896")       if `match' == "LTU"  
         cap: replace latitude = real("49.61")       if `match' == "LUX"  
         cap: replace latitude = real("56.9465")       if `match' == "LVA"  
         cap: replace latitude = real("22.1667")       if `match' == "MAC"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "MAF"  
         cap: replace latitude = real("33.9905")       if `match' == "MAR"  
         cap: replace latitude = real("43.7325")       if `match' == "MCO"  
         cap: replace latitude = real("47.0167")       if `match' == "MDA"  
         cap: replace latitude = real("-20.4667")       if `match' == "MDG"  
         cap: replace latitude = real("4.1742")       if `match' == "MDV"  
         cap: replace latitude = real("19.427")       if `match' == "MEX"  
         cap: replace latitude = real("7.11046")       if `match' == "MHL"  
         cap: replace latitude = real("42.0024")       if `match' == "MKD"  
         cap: replace latitude = real("13.5667")       if `match' == "MLI"  
         cap: replace latitude = real("35.9042")       if `match' == "MLT"  
         cap: replace latitude = real("21.914")       if `match' == "MMR"  
         cap: replace latitude = real("42.4602")       if `match' == "MNE"  
         cap: replace latitude = real("47.9129")       if `match' == "MNG"  
         cap: replace latitude = real("15.1935")       if `match' == "MNP"  
         cap: replace latitude = real("-25.9664")       if `match' == "MOZ"  
         cap: replace latitude = real("18.2367")       if `match' == "MRT"  
         cap: replace latitude = real("-20.1605")       if `match' == "MUS"  
         cap: replace latitude = real("-13.9899")       if `match' == "MWI"  
         cap: replace latitude = real("3.12433")       if `match' == "MYS"  
         cap: replace latitude = real("-22.5648")       if `match' == "NAM"  
         cap: replace latitude = real("-22.2677")       if `match' == "NCL"  
         cap: replace latitude = real("13.514")       if `match' == "NER"  
         cap: replace latitude = real("9.05804")       if `match' == "NGA"  
         cap: replace latitude = real("12.1475")       if `match' == "NIC"  
         cap: replace latitude = real("52.3738")       if `match' == "NLD"  
         cap: replace latitude = real("59.9138")       if `match' == "NOR"  
         cap: replace latitude = real("27.6939")       if `match' == "NPL"  
         cap: replace latitude = real("-0.5477")       if `match' == "NRU"  
         cap: replace latitude = real("-41.2865")       if `match' == "NZL"  
         cap: replace latitude = real("23.6105")       if `match' == "OMN"  
         cap: replace latitude = real("30.5167")       if `match' == "PAK"  
         cap: replace latitude = real("8.99427")       if `match' == "PAN"  
         cap: replace latitude = real("-12.0931")       if `match' == "PER"  
         cap: replace latitude = real("14.5515")       if `match' == "PHL"  
         cap: replace latitude = real("7.34194")       if `match' == "PLW"  
         cap: replace latitude = real("-9.47357")       if `match' == "PNG"  
         cap: replace latitude = real("52.26")       if `match' == "POL"  
         cap: replace latitude = real("18.23")       if `match' == "PRI"  
         cap: replace latitude = real("39.0319")       if `match' == "PRK"  
         cap: replace latitude = real("38.7072")       if `match' == "PRT"  
         cap: replace latitude = real("-25.3005")       if `match' == "PRY"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "PSE"  
         cap: replace latitude = real("-17.535")       if `match' == "PYF"  
         cap: replace latitude = real("25.2948")       if `match' == "QAT"  
         cap: replace latitude = real("44.4479")       if `match' == "ROU"  
         cap: replace latitude = real("55.7558")       if `match' == "RUS"  
         cap: replace latitude = real("-1.95325")       if `match' == "RWA"  
         cap: replace latitude = real("24.6748")       if `match' == "SAU"  
         cap: replace latitude = real("15.5932")       if `match' == "SDN"  
         cap: replace latitude = real("14.7247")       if `match' == "SEN"  
         cap: replace latitude = real("1.28941")       if `match' == "SGP"  
         cap: replace latitude = real("-9.42676")       if `match' == "SLB"  
         cap: replace latitude = real("8.4821")       if `match' == "SLE"  
         cap: replace latitude = real("13.7034")       if `match' == "SLV"  
         cap: replace latitude = real("43.9322")       if `match' == "SMR"  
         cap: replace latitude = real("2.07515")       if `match' == "SOM"  
         cap: replace latitude = real("44.8024")       if `match' == "SRB"  
         cap: replace latitude = real("4.85")       if `match' == "SSD"  
         cap: replace latitude = real("0.20618")       if `match' == "STP"  
         cap: replace latitude = real("5.8232")       if `match' == "SUR"  
         cap: replace latitude = real("48.1484")       if `match' == "SVK"  
         cap: replace latitude = real("46.0546")       if `match' == "SVN"  
         cap: replace latitude = real("59.3327")       if `match' == "SWE"  
         cap: replace latitude = real("-26.5225")       if `match' == "SWZ"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "SXM"  
         cap: replace latitude = real("-4.6309")       if `match' == "SYC"  
         cap: replace latitude = real("33.5146")       if `match' == "SYR"  
         cap: replace latitude = real("21.4602778")       if `match' == "TCA"  
         cap: replace latitude = real("12.1048")       if `match' == "TCD"  
         cap: replace latitude = real("6.1228")       if `match' == "TGO"  
         cap: replace latitude = real("13.7308")       if `match' == "THA"  
         cap: replace latitude = real("38.5878")       if `match' == "TJK"  
         cap: replace latitude = real("37.9509")       if `match' == "TKM"  
         cap: replace latitude = real("-8.56667")       if `match' == "TLS"  
         cap: replace latitude = real("-21.136")       if `match' == "TON"  
         cap: replace latitude = real("10.6596")       if `match' == "TTO"  
         cap: replace latitude = real("36.7899")       if `match' == "TUN"  
         cap: replace latitude = real("39.7153")       if `match' == "TUR"  
         cap: replace latitude = real("-8.6314877")       if `match' == "TUV"  
         cap: replace latitude = real("<wb:latitude")       if `match' == "TWN"  
         cap: replace latitude = real("-6.17486")       if `match' == "TZA"  
         cap: replace latitude = real("0.314269")       if `match' == "UGA"  
         cap: replace latitude = real("50.4536")       if `match' == "UKR"  
         cap: replace latitude = real("-34.8941")       if `match' == "URY"  
         cap: replace latitude = real("38.8895")       if `match' == "USA"  
         cap: replace latitude = real("41.3052")       if `match' == "UZB"  
         cap: replace latitude = real("13.2035")       if `match' == "VCT"  
         cap: replace latitude = real("9.08165")       if `match' == "VEN"  
         cap: replace latitude = real("18.431389")       if `match' == "VGB"  
         cap: replace latitude = real("18.3358")       if `match' == "VIR"  
         cap: replace latitude = real("21.0069")       if `match' == "VNM"  
         cap: replace latitude = real("-17.7404")       if `match' == "VUT"  
         cap: replace latitude = real("-13.8314")       if `match' == "WSM"  
         cap: replace latitude = real("42.565")       if `match' == "XKX"  
         cap: replace latitude = real("15.352")       if `match' == "YEM"  
         cap: replace latitude = real("-25.746")       if `match' == "ZAF"  
         cap: replace latitude = real("-15.3982")       if `match' == "ZMB"  
         cap: replace latitude = real("-17.8312")       if `match' == "ZWE"  
  
******************  Lable: latitude ******************
  
     lab var latitude                    "Capital Latitude" 
 }        
  
 ****************************************************** 
  
 end 
